| 1. | Indeed, a foreign key may itself be a compound key.
|
| 2. | Each foreign key is enforced independently by the database system.
|
| 3. | Therefore, cascading relationships between tables can be established using foreign keys.
|
| 4. | This works because the foreign key holds between attributes with the same name.
|
| 5. | This fact table would be linked to dimensions by means of foreign keys.
|
| 6. | Another recent feature is the configuration of Hierarchic Indexes using foreign key fields.
|
| 7. | A foreign key cannot be mixed like that.
|
| 8. | Reference tables are referenced from Satellites, but never bound with physical foreign keys.
|
| 9. | The foreign key is typically a primary key of an entity it is related to.
|
| 10. | Note that this works because the foreign key holds between attributes with the same name.
|